package com.example.demo.mapper;


import com.example.demo.enity.Bill;
import com.example.demo.enity.Provider;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
@Mapper
public interface ProviderListMapper {

    public List<Provider> getProviderListByWhere(Provider provider);

    public Provider findById(Integer code);

    public int providerAddMapper(Provider provider);

    public int updateProviderByProvider(Provider provider);

    @Delete("delete\n" +
            "from provider_table\n" +
            "where code = #{code}")
    public int remove(Integer code);
}
